2017-08-25 - 55156 - Enhancement - Hot Market Scorecard Update #CrystalReportsSupport

ENHANCEMENT

55156 - Hot Market Scorecard Update

Requirement Summary

Need to update the MLB HOT Market Season and Collections in Scorecards.

Admin Info

Purpose
 Need to update the MLB HOT Market Season and Collections in Scorecards.
Requested By
 Saravanan Lakshmanan
Spec Created By
 Dhananjay G
Spec Created Date
 08/25/2017
Spec QA by
 Uday Kumar P
Objects
 SA110 & SA115
Document Status
 Complete

Estimates

SNo
 Activity
 Estimation in Hours
1
 Research
 00
2
 Documentation
 00
3
 Development/ Config
 08
4
 Unit test in DEV
 02
5
 Unit test in QUA
 00
6
 Other activity
 00

TOTAL
 10

References

Prior Tickets

None

Documents

MLB Hot Market SEA and COL.xls

Spec Changes

SNo
 Change Details
 Requested By
 Requested On
 Notes if any










Functional Requirement

Purpose/WHY:

Please omit the attached season and collections from the landing page of the scorecard.

In Scope:

Global Region.

Out of Scope:

Other Regions.

Solution Summary

1. Need to create new Scorecard reports for MLB HOT Market by using NFL reports.
2. Need to add provided season and collections in Scorecard reports.
3. Need to validate the report with BW BEx query.
4. Need to promote the report into BI Production after successful validation.

Test Plan

SNo.
 Test Scenario
 Expected Results
1.
 Report Format.
 As per NEC standards.
2.
 Execute Crystal Report in Crystal Designer tool after changes.
 Report should execute successfully in Crystal Designer tool.
3.
 Schedule the Report in NEC BI Launch Pad.
 Report should execute successfully in NEC BI Launch Pad.

Solution Details

1. Created two reports for MLB Hot Market:
SA110 - Corporate Scorecard - NFL & MLB HM removed.
SA115 - Corporate Scorecard By Regions - NFL & MLB HM removed.

2. Added the below collections to all the formula fields in reports(Bold letters as New Codes):
{Sheet1_.[0AF_COLL]-[20AF_COLL]} IN ['HK1','HK2','HK3','HK4','HM1','HM2','HM3','HM4','HM6','HM8','HM9','HW1','HW2','K064','K065','K068','K077','K078','K079','K080','K081','K082','K083','K084','K085','K086',
'K087','K088','K089','K090','K091','K092','K348','K349','K350','K351','K352','K353','K354','K355','K356','M871','M872','M873','M874','M897','M898','M899','M900','M901','M902','M903','M904','M905','M906','M907','M908','M909','M910']).

3. Validated the report with BW BEx queries:
scorecard mlb collections removed.jpg

4. The report is promoted to BI Production successfully by NEC.

Issues

None